package com.mai.demo.mapper;

import com.mai.demo.entity.domain.Teacher;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author MR
* @description 针对表【teacher】的数据库操作Mapper
* @createDate 2024-12-23 10:08:26
* @Entity generator.domain.Teacher
*/
public interface TeacherMapper extends BaseMapper<Teacher> {
    @Select("SELECT trNum as teacherId, CONCAT(trFirstName, trName) as teacherName " +
            "FROM teacher " +
            "WHERE CONCAT(trFirstName, trName) = #{teacherName} limit 1")
    Teacher getList(String teacherName);
}




